SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Inserts a record into the UserType table
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.UserType_Insert
(

	@Id int    OUTPUT,

	@Title nvarchar (50)  
)
AS


				
				INSERT INTO [dbo].[UserType]
					(
					[Title]
					)
				VALUES
					(
					@Title
					)
				
				-- Get the identity value
				SET @Id = SCOPE_IDENTITY()
									
							
			

GO
